• a5_finddupsgenie Function
• a5_get_recs_in_qry_local Function
• a5_paste_current_record Function
• a5_paste_from_clipboard Function
• a5_paste_new_record Function
• a5_put_rec_on_clipboard Function
• a5_rec_clip_has_data Function
• a5_records_undelete Function
• a5_remove_recs_genie Function
• a5_selected_records Function
• BOTTOM_PERCENT_RECORDS Function
• BOTTOM_RECORDS Function
• CHANGE_RECORD Method
• CURRENT_RECORD Function
• CURRENT_RECORD_NUMBER Function
• DBAVG Function
• DBCOUNT Function
• DBMAX Function
• DBMIN Function
• DBSUM Function
• DELETE_RECORD Method
• DELETED Function
• ENTER RECORD Method
• EVERY_RECORD_LIST Function
• FILTER_STRING Function
• form_qs_explicit Function
• IS_RECNO_IN Function
• LOOKUP Function
• LOOKUPC Function
• LOOKUPD Function
• LOOKUPL Function
• LOOKUPN Function
• MARKED Function
• page_records_get Function
• POP_STDDEV Function
• POP_VARIANCE Function
• RANDOM_PCT_RECORD_LIST Function
• RANDOM_PERCENT_RECORDS Function
• RANDOM_RECORD_LIST Function
• RANDOM_RECORDS Function
• RECORD_ADD Function
• RECORD_DELETE Function
• RECORD_UPDATE Function
• RUN_AVERAGE Function
• RUN_MAXIMUM Function
• RUN_MINIMUM Function
• RUN_STDDEV Function
• RUN_VARIANCE Function
• SAMPLE_RECORDS Function
• STDDEV Function
• TOP_PERCENT_RECORDS Function
• TOP_RECORDS Function
• TOP_RECORDS_LIST Function
• TOP_RECORDS_PCT_LIST Function
• VARIANCE Function

CHANGE_RECORD Method

Syntax

Arguments

var

A dot variable with the field values from the specified table.

Description

Allows for data to be changed via Xbasic, when using a Form or Browse. Returns a dot variable that is the validation object.

The example below shows how to use the .change_record() method:

'DIM a dot variable with properties that match the fieldnames you want to change
dim r as p
r.firstname = ""
r.company = "alpha"
v = t.change_record(r)
?v.has_errors
= .T.
?v.error.size()
= 2

?v.Format("$(field) = $(error)"+crlf())
= CUSTOMER1->COMPANY = company can't be alpha
CUSTOMER1->LASTNAME = Field is required: LASTNAME

As the example shows, a dot variable is created with properties for all of the fields that you want to enter/change. In the above example, we enter or change the 'firstname' and 'company' fields in the customer table. Once the dot variable has been created, the <Tbl>.change_record() method is called. This method takes as its argument the dot variable with the field values.

The method returns a dot variable. The dot variable has an 'has_errors' property which lets you know if the method succeeded or not. If not, then the errors are returned in an array called 'errors' which is a sub-property of the dot variable. The dot variable that is returned by the .change_record() method is actually an object (the 'validation' object), and it has a .Format() method, which allows you to format the error message into a friendly text or html format ready for display to the user. The format() method can use these placeholders:

$(field)

Placeholder for the fieldname for which the error occurred

$(error)

Placeholder for the plain-text error message

$(errorhtml)

Placeholder for the HTML formatted error message

In the above example, you can see that we call the .Format() method with this argument:

"$(field) = $(error)"+crlf()

The crlf() is necessary because the .Format() method does not put in line breaks between each message. The string "$(field) = $(error)" contains two placeholders which get replaced by each field for which an error occurred and by the corresponding error message.

See Also

• ENTER_RECORD Method
• DELETE_RECORD Method
• Field Rules Honored During Xbasic Data Entry